![]() | ![]() | ![]() | ![]() |
The SYSERR automatic macro variable might not be set to a nonzero value when the IMPORT procedure fails. The problem occurs under the following circumstances:
proc import datafile='c:\sastest\myexcel.xls' out=sastest dbms=xls; sheet='barney'; run; Requested Sheet Name not found on Excel -> c:\sastest\myexcel.xls Requested Input File Is Invalid ERROR: Import unsuccessful. See SAS Log for details. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds %put &syserr; 0
In this example, the correct value of SYSERR is 1012.
A fix for this issue is planned for a future release.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for x64 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Datacenter Edition | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
Microsoft Windows Server 2003 Enterprise Edition | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
Microsoft Windows Server 2003 Standard Edition | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
Microsoft Windows Server 2003 for x64 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
Microsoft Windows Server 2008 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
Microsoft Windows Server 2008 for x64 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
Microsoft Windows XP Professional | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
Windows 7 Enterprise 32 bit | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
Windows 7 Enterprise x64 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
Windows 7 Home Premium 32 bit | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
Windows 7 Home Premium x64 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
Windows 7 Professional 32 bit | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
Windows 7 Professional x64 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
Windows 7 Ultimate 32 bit | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
Windows 7 Ultimate x64 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
Windows Vista | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 | ||
Windows Vista for x64 | 9.3 | 9.3_M2 | 9.3 TS1M0 | 9.3 TS1M2 |